Carson Penticuff
Carson Penticuff
Reactions
-
Re: Count Values of X if Y is not the same for the other Xs
The helper column counts the number of times the advisor appears with 1 in the Meeting Number column. If a given advisor is listed with four different clients, the helper column will show 4 on each o…1 · -
Re: "Boolean Expected" Error
It sounds like you are attempting to either check or not check a box based on the content of another sheet. The way your formula is structured, you will be returning the value of {GenFertCalc}. Unles…2 · -
Re: Total invoiced within a date range
Okay… so a couple of issues. There are some extra spaces in your formula: [PO’s date]:[ PO’s date] | Notice the extra space before PO in the second set of brackets. DATE (2025,1,1) | There should not…1 · -
Re: CountIfs results 0
The current month is simpler due to not having to account for the possibility of wrapping into a different year. =COUNTIFS({Design Request Tracker Range 1}, ISDATE(@cell), {Design Request Tracker Ran…1 · -
Re: CountIfs results 0
You are correct in that the rollover to 2025 is causing your issue. The formula, as it stands, is looking for dates within the current year, then subtracting one month from today. Since today is mont…1 ·
